package cn.qayy.dao;

import cn.qayy.dto.*;
import cn.qayy.po.KdbNssLogClientPolicy;

import java.util.Collection;
import java.util.List;
import java.util.Map;

/**
 * @author jobs1127
 */
public interface PlansMapper {
    //测试方法
    public List<MyTestUser> selectAll();

    public Integer selectCountId(MyTestUser user);

    public List<FeiYong> selectCx2017Sum();

    public List<FeiYong> selectCx2018Sum();

    public List<FeiYong> selectCx2018Space();

    public List<FeiYong> selectCx2017Space();

    public List<FeiYong> selectXs2017Sum();

    public List<FeiYong> selectXs2018Sum();

    public List<FeiYong> selectXs2018Space();

    public List<FeiYong> selectXs2017Space();

    //所有的自然流向
    public Integer selectNatural();

    //真正的自然流向
    public Integer selectRealNatural();

    public Integer selectClientCount();

    public Integer selectTerminalCount();

    public List<Plans> select2018RxCxScount();

    public List<Plans> select2018RxCxScountCurrentMonth();

    public List<Plans> select2018OTCCxScount();

    public List<Plans> select2018OTCCxScountCurrentMonth();

    public List<Plans> selectProvince2018CxScount();

    List<ReportPlans> download_allXsPlans();

    List<ReportPlans> download_all2017Plans();

    List<ReportPlans> download_all2017CxPlans();

    List<ReportPlans> download_all2017XsPlans();

    List<ReportPlans> download_all2018Plans();

    List<ReportPlans> download_all2018CxPlans();

    List<ReportPlans> download_all2018XsPlans();

    List<ReportPlans> download_all();

    Integer selectOldYear2016CxPlansAllSum();

    Integer selectOldYear2016XsPlansAllSum();

    Integer selectOldYear2017CxPlansAllSum();

    Integer selectOldYear2017XsPlansAllSum();

    List<TerminalPlans> selectOldTerminals();

    List<TerminalPlans> selectMaybeNewTerminals();

    List<QudaoProvinceData> download_2018qudaoAndProvice();

    List<QudaoSpaceData> download_2018qudaoAndSpace();

    List<ProductProvinceData> download_2018productAndprovice();

    List<ProductSpaceData> download_2018productAndSpace();

    List<QudaoProvinceData> download_2017qudaoAndProvice();

    List<QudaoSpaceData> download_2017qudaoAndSpace();

    List<ProductProvinceData> download_2017productAndprovice();

    List<ProductSpaceData> download_2017productAndSpace();

    List<Plans> selectBigSpace2018CxScount();

    List<Plans> selectSpace2018CxScount();

    List<Terminal1000> download_2018MonthPVG1000Terminal();

    List<Country1000> download_2018MonthPVG1000Country();

    List<Terminal1000> download_2017MonthPVG1000Terminal();

    List<Country1000> download_2017MonthPVG1000Country();

    List<PlansView> selectPlans(Map<String, Object> params);

    List<GoodFriend1000> download_cx2018goodfriend1000();

    List<TPPScountData> download_2018cxTPP1();

    List<TPPScountData> download_2018cxTPP2();

    List<TPPScountData> download_2018cxTPP3();

    List<TPPScountData> download_2018cxTPP4();

    List<TPPScountData> download_2018cxTPP5();

    List<TPPScountData> download_2018cxTPP6();

    List<TPPScountData> download_2018cxTPP7();

    List<TPPScountData> download_2018cxTPP8();

    List<TPPScountData> download_2018cxTPP9();

    List<TPPScountData> download_2018cxTPP10();

    List<TPPScountData> download_2018cxTPP11();

    List<TPPScountData> download_2018cxTPP12();

    List<MgrsProvinces> selectMgrsProvinces();

    List<ReportPlans> download_all2017_2018Plans();

    List<ReportPlans> download_all_cx_2016_2018Plans();

    List<ReportPlans> download_all2016CxPlans();

    List<ReportPlans> download_all2015CxPlans();

    List<ReportPlans> download_all2014CxPlans();

    List<ReportPlans> download_all2014_2015CxPlans();

    List<ReportPlans> download_all2015_2016CxPlans();

    List<ReportPlans> download_all2016_2017CxPlans();

    List<ReportPlans> download_all2017_2018CxPlans();

    List<ReportPlans> download_all2014_2015XsPlans();

    List<ReportPlans> download_all2015_2016XsPlans();

    List<ReportPlans> download_all2016_2017XsPlans();

    List<ReportPlans> download_all2017_2018XsPlans();

    Collection<? extends ReportPlans> download_all2016Plans();

    Collection<? extends ReportPlans> download_all2015Plans();

    Collection<? extends ReportPlans> download_all2014Plans();

    Collection<? extends ReportPlans> download_2017_2018_allPlans();

    List<KdbNssLogClientPolicyItem> download_policy_self(Map<String, Object> params) throws Exception;

	public List<ReportPlansTerminal> download_allP6CxPlans();

	public List<ReportPlansTerminal> download_all2018CxPlans_terminal();

	public List<KdbNssLogClientPolicyItem> download_policy(Map<String, Object> params);

	public Collection<? extends ReportPlans> download_all2019CxPlans();

	public Collection<? extends ReportPlans> download_all2018_2019CxPlans();

	public Collection<? extends ReportPlans> download_2018_2019_allPlans();

	public Collection<? extends ReportPlans> download_all2019Plans();

	public Collection<? extends ReportPlansJ> download_all2019Plans_J();

	public Collection<? extends ReportPlansQ> download_all2019Plans_Q();
	
	public Collection<? extends ReportPlansZ> download_all2019Plans_Z();
}
